SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Large Lebanon house located in the business district. Commercial zoning. 3-4 bedrooms, 2 baths with a full walk out basement and 1 car garage. Spacious rooms, first floor laundry and the enclosed side porch is a nice feature. The yard has lilacs and a few trees that make it feel a bit more private, while still in the middle of town. Walk the rail trail that is located across the street. Convenient to most everything.
Description:Don’t wait until the seller has the home fully renovated to buy. Signicfacnt price increase when the home is complete condition. Get in an buy a home in a great neighborhood that you can finish and add your own touches too. Painting will be completed this coming week. The drywall is being replaced actively. ( Photos will be uploaded once done) Built in 1967, this ranch sits on a quiet 0.35-acre lot in West Lebanon neighborhood of pasture lane, offering the perfect opportunity for a fix-and-flip, investment property or family home. The seller's updates are just the beginning, making this an ideal time to get in and shape the home to your vision. THIS HOME IN FULLY RENOVATED CONDITION WILL BE WORTH FAR MORE THAN CURRENT LISTING PRICE, making this an awesome Christmas present, in preparation for the new year. While the home is being sold in as-is (new paint) condition, its location, layout, and potential make it a rare find. The seller is motivated and open to offers, don’t miss your chance to bring this property to life and create a newly remodeled home or lucrative investment opportunity. Get in now why renovation are still underway.
Description:Step inside through the marble checkered entry tile and take in the vaulted ceilings, creating an airy, open ambiance. The main living spaces feature gleaming cherry hardwood floors, warm wood paneling, interesting architectural design and enough space to gather and host. For the culinary enthusiast, the kitchen has a beautiful wide high-end Sub-Zero refrigerator, Wolf propane range, and ample counter space. There is a laundry room/mudroom off the kitchen and an ensuite bedroom off the living room perfectly suited for single level living. Upstairs, you'll find two more generous bedrooms with a jack-and-jill bathroom, a walk in cedar closet, and shelves for all your books, decor, and craft supplies. Above the attached two car garage you'll find a bonus area, perfect for finishing into a home office, gym, or extra living space. The garage already has a propane Rinnai heater. There is a private drilled well with reverse osmosis system for crisp water, and the house has a whole house Kohler generator that jumps right into action if needed. There is a wonderful deck with additional screened in porch that is quiet and ready for you to bring a book and enjoy the nature surrounding the property. With all the right bones in place, this property is ready to be transformed into your perfect oasis. Don't miss the chance to make this home yours in the sought-after Eastman community with tennis, skiing, trails and more.
Description:A fantastic location, just 15 or 20 minutes to the Upper Valley or New London area on paved roads. Traditional layout with updates of new kitchen, baths, windows, spray foam insulation, plus many original features add to the charm with refinished wide pine floors, moldings, 4 panel solid wood doors, and built ins. Kitchen/Dining with new flooring, former summer kitchen is now a 3 season hobby room with woodstove, 2 baths on the first floor, one bath has a washer/dryer that are included. Depending on how you want to use the rooms you could have a formal dining room for family gatherings over the holidays, there is a primary bedroom & bath, music/office room on the first floor, and two bedrooms on the second floor. 3.3 surveyed acres+/- with Knox River frontage to cool off next to, beautiful backyard with rolling lawns, apple trees, and a foot bridge to the unspoiled woodlands. Attached ell with storage above as well as loft above the barn. Enjoy all the area has to offer with Farmer's Market on Saturday, Concerts, area lakes/ponds with public access. Dartmouth College, VA hospital, & Dartmouth Medical Center are within convenient travel time.
Description:This 3 bedroom ranch sits on 6.2 remote acres out in the rural stretches of the Hanover School District. With a large shop space and expansive gardening space, this is a wonderful location to enjoy. This property is a part of the Rennie Road Value Assurance Program provided by Dartmouth College. For more information, please ask the agent or your buyer's agent!
Description:Spectacular yard that gently slopes down to the Brook. With 273' along the brook, this is a special property. Ample space for large gatherings, camp fires or garden space. This light and bright 3 bedroom ranch has been updated over the years, with a modern kitchen and hardwood flooring. Relax by the woodstove in the family room or sit back and enjoy a book in the sunroom. Plenty of rooms for everyone to enjoy. There is a full unfinished basement, a wonderful back deck with a 2024 hot tub. Did I mention the oversized garage? 28 x 60' for parking, workshop area or just extra storage for all the fun toys you may acquire. In 2007 the septic was updated. 2.7 acres of land to enjoy. Located conveniently to shopping and just 15 Minutes to DHMC.
Description:PRICE IMPROVEMENT! This 3 bedroom/2 bathroom home is ready for its next owners! Located in one of Lebanon's most desirable locations, the King's Grant neighborhood, it's close to shopping, dining, and schools, and backs up to Carter Country Club. The first floor features a mudroom or bonus room, office, and utility/laundry room and also connects to the garage. Upstairs, you'll find a large living room with high ceilings, a kitchen featuring brand new stainless steel appliances, and a dining area leading to a large, private deck. A primary bedroom with en-suite 3/4 bath and 2 other bedrooms which share a full bath complete the space. Hanover, Dartmouth Hitchcock Medical Center, and West Lebanon shopping are all within a 15 minute drive. You'll love living in the heart of the Upper Valley!
Description:Nestled along the shores of Mascoma Lake and surrounded by the historic Shaker Museum you’ll find the community of North Village. A unique cluster of lovely homes, stylized with a hint of day’s gone by yet very modern on the interior. That’s exactly what you’ll find at 51 Chosen Vale Lane, built in 2002 and lovingly cared for this home has many features not found in the others. The large primary suite consists of vaulted ceilings, a separate dressing/sitting room with fireplace and spacious bath. The additional second floor suite again boasts a private bath, and a loft for those adventurous ones in the family. The main level is perfect for entertaining with an open concept living room, kitchen and dining room with built-ins and hardwood floors throughout. Red Birch & Mahogany cabinets, granite countertops and plenty of room for the best of cooks. The living room center piece is a fireplace mantel hand crafted by Dana Robes. A first-floor bedroom with a full bath rounds off the main level. A fully covered 3 season porch allows for lovely views of the lake, all within a short walk to the private Association beach. The lower level has a wonderful family room complete with bar, workshop, storage and laundry. The systems include two Air conditioning units one for each floor, a Buderus heating system, and a whole house sprinkler system. The Association maintains the roads, landscaping and beaches. Easy commute to Dartmouth College and the Dartmouth Medical Center.
Description:If you are looking for a home that has a country feel, with a scenic country road access, yet offers Windsor VT, Claremont and the Upper Valley of NH, all within a 25 minute drive or less, this location will speak to you. This is a custom built home, that has hillside views (can be improved with some clearing), a brook at the north end of the property, a detached 2 car garage (2016), standby generator, privacy and gardens. Inside you have large spaces, vaulted ceilings, wood beams, a kitchen with a view and granite counters. The stone fireplace goes two stories high. In some houses that would be the focal point, this home offers several. The sunroom, it is sunny and bright, take in the view and stay warm with the gas fireplace. Step out onto the deck and take in the fresh air. The primary suite is large, has direct access to the deck and a bath that is just a dream. There is space for a in-home gym and office. The second floor has an open loft, two large bedrooms and full bath. Radiant heat on the main floor keeps you warm all winter and the newer metal roof gives you peace of mind. Other features: hardwood floors, paved driveway, pellet stove, water filtration, dumbwaiter and more! Delayed showings, showings start at the open house on Saturday 09/07 11am-1pm
Description:Welcome to your brand-new home in Hanover! This beautifully designed new construction features a spacious open floor plan, ideal for both entertaining and enjoying peaceful nights at home. With convenient first-floor laundry hookups and a maintenance-free lifestyle, this home offers all the modern amenities you need. Hardwood floors, masterfully designed bathrooms with custom tile showers, a spectacular kitchen with Quartz countertops, fully appliances kitchens, and tile back splash. Primary Suite is stunning and offers lots.of privacy from the rest of the home. Located just minutes from Dartmouth College, Dartmouth-Hitchcock Medical Center, and several ski resorts, it provides unmatched convenience and accessibility. Whether you're working on campus or exploring the vibrant Hanover area, this location can't be beat. Don't miss the chance to make this your new home—ready for immediate occupancy! Schedule a showing today and start imagining your life in this dream home. Home is complete and move-in ready! The seller is a licensed New Hampshire real estate broker. Seller is a licensed New Hampshire real estate broker